summary
This seems so elementary, but I don't use these very often and it seems like every time I get a little stuck, so I decided it's worth documenting. This is how to display multiple rows of data from a single Notes document. I often use this concept when I have a business area that needs a report.
document fields overview
Client Name (1 per document)
Policy
(1 per document (i.e. 1 per client)) Services (many per document)
Date of Service (many per document (i.e. 1 per service))
comments
is a multi-value checkbox field on our document
view - column 1 (Client Name)
same for each record, so we don't need to check "show multiple values as separate entries", but we could it won't matter one way or the other
view - column 2 (Policy)
same for each record, so we don't need to check "show multiple values as separate entries" view - column 3 (Services)
first multi-value column, must be sorted ascending, and must have "show multiple values as separate entries" checked
if we check "show multiple values as separate entries", but don't check "ascending" sort, we only see the 1st value (2nd and subsequent values are missing)
if we uncheck "show multiple values as separate entries", and check "ascending" sort, we see both values, but on the same row, not on separate rows how we want
view - column 4 (Date of Service)
no sort ascending/descending needed, but we do need "show multiple values as separate entries" checked. Each service has a unique date field which is why we need this. If the date was the same for each it wouldn't matter